TankReading

Entity Definition

Logical Name : TankReading
Physical Name : DO_RDG_TNK

A reading of the height (and/or volumes) of Fuel and Water measurements of the contents of a Tank.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer TankProbe(AS_PBE_TNK)
TankID (FK)(PK) A unique identifier for this Tank ID_TNK Identity integer TankProbe(AS_PBE_TNK)
TankProbeID (FK)(PK) A system assigned unique identifier for the TankProbe ID_PBE_TNK Identity integer TankProbe(AS_PBE_TNK)
ReadingNumber (PK) A unique identifier for this particular reading on this TankProbe AI_RDG LineNumber smallint
DateTimeStamp The date & time the reading was taken TS_RDG AuditDateTime datetime
ProductLevel The measured level of the product in the Tank QU_LV_PDT Quantity DECIMAL(9,3)
TotalObservedVolume The volume of product (including free water) in the tank. QV_OBS Quantity DECIMAL(9,3)
GrossStandardVolume The volume, excluding the free water in the tank, corrected to reference temperature. QV_GS_STD Quantity DECIMAL(9,3)
AverageTemperature The average temperature of the product in the tank QU_TEMP_AV Quantity DECIMAL(9,3)
ObservedDensity The average density of the product QU_DNSTY_OBS Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
TankProbe records TankReading
TankReading was performed via PhysicalCountLineItem

Logical Views containing TankReading

Logical View
Logical 02010 - Item Inventory - Adjustments View
Logical 20000 - Forecourt Macro View
Logical 20050 - Forecourt Tank Gauge View